Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 164750 |
| Missing cells | 472018 |
| Missing cells (%) | 13.6% |
| Duplicate rows | 5 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 87.0 MiB |
| Average record size in memory | 553.7 B |
Variable types
| NUM | 10 |
|---|---|
| CAT | 10 |
| BOOL | 1 |
Reproduction
| Analysis started | 2023-01-01 00:47:27.832291 |
|---|---|
| Analysis finished | 2023-01-01 00:47:53.426356 |
| Duration | 25.59 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 5 (< 0.1%) duplicate rows | Duplicates |
batsman has a high cardinality: 488 distinct values | High cardinality |
non_striker has a high cardinality: 484 distinct values | High cardinality |
bowler has a high cardinality: 378 distinct values | High cardinality |
player_dismissed has a high cardinality: 464 distinct values | High cardinality |
fielder has a high cardinality: 476 distinct values | High cardinality |
total_runs is highly correlated with batsman_runs | High correlation |
batsman_runs is highly correlated with total_runs | High correlation |
player_dismissed has 156593 (95.0%) missing values | Missing |
dismissal_kind has 156593 (95.0%) missing values | Missing |
fielder has 158832 (96.4%) missing values | Missing |
bye_runs is highly skewed (γ1 = 30.0515634) | Skewed |
noball_runs is highly skewed (γ1 = 24.97400437) | Skewed |
wide_runs has 159739 (97.0%) zeros | Zeros |
bye_runs has 164302 (99.7%) zeros | Zeros |
legbye_runs has 161989 (98.3%) zeros | Zeros |
noball_runs has 164093 (99.6%) zeros | Zeros |
batsman_runs has 65904 (40.0%) zeros | Zeros |
extra_runs has 155872 (94.6%) zeros | Zeros |
total_runs has 58061 (35.2%) zeros | Zeros |
match_id
Real number (ℝ≥0)
| Distinct count | 696 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 977.9517572078908 |
|---|---|
| Minimum | 1 |
| Maximum | 7953 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 175 |
| median | 349 |
| Q3 | 521 |
| 95-th percentile | 7919 |
| Maximum | 7953 |
| Range | 7952 |
| Interquartile range (IQR) | 346 |
Descriptive statistics
| Standard deviation | 2147.671843 |
|---|---|
| Coefficient of variation (CV) | 2.196091808 |
| Kurtosis | 6.501191032 |
| Mean | 977.9517572 |
| Median Absolute Deviation (MAD) | 173 |
| Skewness | 2.901470981 |
| Sum | 161117552 |
| Variance | 4612494.344 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 126 | 267 | 0.2% | |
| 34 | 263 | 0.2% | |
| 476 | 262 | 0.2% | |
| 534 | 262 | 0.2% | |
| 388 | 261 | 0.2% | |
| 190 | 259 | 0.2% | |
| 570 | 259 | 0.2% | |
| 536 | 258 | 0.2% | |
| 401 | 258 | 0.2% | |
| 257 | 257 | 0.2% | |
| Other values (686) | 162144 | 98.4% |
| Value | Count | Frequency (%) | |
| 1 | 248 | 0.2% | |
| 2 | 247 | 0.1% | |
| 3 | 218 | 0.1% | |
| 4 | 247 | 0.1% | |
| 5 | 248 | 0.2% |
| Value | Count | Frequency (%) | |
| 7953 | 241 | 0.1% | |
| 7952 | 245 | 0.1% | |
| 7951 | 247 | 0.1% | |
| 7950 | 247 | 0.1% | |
| 7949 | 247 | 0.1% |
inning
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 43 |
| 4 | 38 |
| Value | Count | Frequency (%) | |
| 1 | 85409 | 51.8% | |
| 2 | 79260 | 48.1% | |
| 3 | 43 | < 0.1% | |
| 4 | 38 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
batting_team
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Mumbai Indians | |
|---|---|
| Royal Challengers Bangalore | |
| Kings XI Punjab | |
| Kolkata Knight Riders | |
| Delhi Daredevils | |
| Other values (8) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 20673 | 12.5% | |
| Royal Challengers Bangalore | 19300 | 11.7% | |
| Kings XI Punjab | 19211 | 11.7% | |
| Kolkata Knight Riders | 19155 | 11.6% | |
| Delhi Daredevils | 18786 | 11.4% | |
| Chennai Super Kings | 17711 | 10.8% | |
| Rajasthan Royals | 15677 | 9.5% | |
| Sunrisers Hyderabad | 11132 | 6.8% | |
| Deccan Chargers | 9034 | 5.5% | |
| Pune Warriors | 5443 | 3.3% | |
| Other values (3) | 8628 | 5.2% |
Length
| Max length | 27 |
|---|---|
| Mean length | 17.99498634 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 21 | 56.8% | |
| Uppercase_Letter | 15 | 40.5% | |
| Space_Separator | 1 | 2.7% |
| Value | Count | Frequency (%) | |
| Latin | 36 | 97.3% | |
| Common | 1 | 2.7% |
| Value | Count | Frequency (%) | |
| ASCII | 37 | 100.0% |
bowling_team
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Mumbai Indians | |
|---|---|
| Royal Challengers Bangalore | |
| Kolkata Knight Riders | |
| Kings XI Punjab | |
| Delhi Daredevils | |
| Other values (8) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 20573 | 12.5% | |
| Royal Challengers Bangalore | 19627 | 11.9% | |
| Kolkata Knight Riders | 19290 | 11.7% | |
| Kings XI Punjab | 19055 | 11.6% | |
| Delhi Daredevils | 18725 | 11.4% | |
| Chennai Super Kings | 17533 | 10.6% | |
| Rajasthan Royals | 15813 | 9.6% | |
| Sunrisers Hyderabad | 10936 | 6.6% | |
| Deccan Chargers | 9039 | 5.5% | |
| Pune Warriors | 5457 | 3.3% | |
| Other values (3) | 8702 | 5.3% |
Length
| Max length | 27 |
|---|---|
| Mean length | 18.01981791 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 21 | 56.8% | |
| Uppercase_Letter | 15 | 40.5% | |
| Space_Separator | 1 | 2.7% |
| Value | Count | Frequency (%) | |
| Latin | 36 | 97.3% | |
| Common | 1 | 2.7% |
| Value | Count | Frequency (%) | |
| ASCII | 37 | 100.0% |
over
Real number (ℝ≥0)
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.151878603945372 |
|---|---|
| Minimum | 1 |
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 10 |
| Q3 | 15 |
| 95-th percentile | 19 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.675665868 |
|---|---|
| Coefficient of variation (CV) | 0.5590754273 |
| Kurtosis | -1.18230573 |
| Mean | 10.1518786 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.05167105171 |
| Sum | 1672522 |
| Variance | 32.21318305 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 8837 | 5.4% | |
| 2 | 8763 | 5.3% | |
| 3 | 8672 | 5.3% | |
| 4 | 8644 | 5.2% | |
| 5 | 8612 | 5.2% | |
| 6 | 8607 | 5.2% | |
| 7 | 8561 | 5.2% | |
| 8 | 8528 | 5.2% | |
| 9 | 8510 | 5.2% | |
| 10 | 8450 | 5.1% | |
| Other values (10) | 78566 | 47.7% |
| Value | Count | Frequency (%) | |
| 1 | 8837 | 5.4% | |
| 2 | 8763 | 5.3% | |
| 3 | 8672 | 5.3% | |
| 4 | 8644 | 5.2% | |
| 5 | 8612 | 5.2% |
| Value | Count | Frequency (%) | |
| 20 | 6186 | 3.8% | |
| 19 | 7197 | 4.4% | |
| 18 | 7692 | 4.7% | |
| 17 | 7941 | 4.8% | |
| 16 | 8040 | 4.9% |
ball
Real number (ℝ≥0)
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6162427921092566 |
|---|---|
| Minimum | 1 |
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.807397715 |
|---|---|
| Coefficient of variation (CV) | 0.4997998804 |
| Kurtosis | -1.082362006 |
| Mean | 3.616242792 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.09647601544 |
| Sum | 595776 |
| Variance | 3.266686501 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 26715 | 16.2% | |
| 2 | 26640 | 16.2% | |
| 3 | 26567 | 16.1% | |
| 4 | 26504 | 16.1% | |
| 5 | 26419 | 16.0% | |
| 6 | 26328 | 16.0% | |
| 7 | 4728 | 2.9% | |
| 8 | 736 | 0.4% | |
| 9 | 113 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 26715 | 16.2% | |
| 2 | 26640 | 16.2% | |
| 3 | 26567 | 16.1% | |
| 4 | 26504 | 16.1% | |
| 5 | 26419 | 16.0% |
| Value | Count | Frequency (%) | |
| 9 | 113 | 0.1% | |
| 8 | 736 | 0.4% | |
| 7 | 4728 | 2.9% | |
| 6 | 26328 | 16.0% | |
| 5 | 26419 | 16.0% |
| Distinct count | 488 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| V Kohli | 3879 |
|---|---|
| SK Raina | 3723 |
| G Gambhir | 3524 |
| RG Sharma | 3497 |
| S Dhawan | 3384 |
| Other values (483) |
| Value | Count | Frequency (%) | |
| V Kohli | 3879 | 2.4% | |
| SK Raina | 3723 | 2.3% | |
| G Gambhir | 3524 | 2.1% | |
| RG Sharma | 3497 | 2.1% | |
| S Dhawan | 3384 | 2.1% | |
| RV Uthappa | 3234 | 2.0% | |
| MS Dhoni | 3001 | 1.8% | |
| AM Rahane | 2925 | 1.8% | |
| DA Warner | 2902 | 1.8% | |
| CH Gayle | 2793 | 1.7% | |
| Other values (478) | 131888 | 80.1% |
Length
| Max length | 20 |
|---|---|
| Mean length | 9.361317147 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 48.1% | |
| Lowercase_Letter | 26 | 48.1% | |
| Space_Separator | 1 | 1.9% | |
| Dash_Punctuation | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 96.3% | |
| Common | 2 | 3.7% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 484 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| SK Raina | 3832 |
|---|---|
| G Gambhir | 3740 |
| V Kohli | 3705 |
| S Dhawan | 3650 |
| RG Sharma | 3540 |
| Other values (479) |
| Value | Count | Frequency (%) | |
| SK Raina | 3832 | 2.3% | |
| G Gambhir | 3740 | 2.3% | |
| V Kohli | 3705 | 2.2% | |
| S Dhawan | 3650 | 2.2% | |
| RG Sharma | 3540 | 2.1% | |
| AM Rahane | 3192 | 1.9% | |
| RV Uthappa | 3125 | 1.9% | |
| CH Gayle | 2714 | 1.6% | |
| MS Dhoni | 2712 | 1.6% | |
| KD Karthik | 2709 | 1.6% | |
| Other values (474) | 131831 | 80.0% |
Length
| Max length | 20 |
|---|---|
| Mean length | 9.362324734 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 48.1% | |
| Lowercase_Letter | 26 | 48.1% | |
| Space_Separator | 1 | 1.9% | |
| Dash_Punctuation | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 96.3% | |
| Common | 2 | 3.7% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 378 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Harbhajan Singh | 3182 |
|---|---|
| A Mishra | 2929 |
| PP Chawla | 2890 |
| SL Malinga | 2694 |
| R Ashwin | 2673 |
| Other values (373) |
| Value | Count | Frequency (%) | |
| Harbhajan Singh | 3182 | 1.9% | |
| A Mishra | 2929 | 1.8% | |
| PP Chawla | 2890 | 1.8% | |
| SL Malinga | 2694 | 1.6% | |
| R Ashwin | 2673 | 1.6% | |
| P Kumar | 2637 | 1.6% | |
| DJ Bravo | 2448 | 1.5% | |
| UT Yadav | 2366 | 1.4% | |
| B Kumar | 2340 | 1.4% | |
| SP Narine | 2327 | 1.4% | |
| Other values (368) | 138264 | 83.9% |
Length
| Max length | 17 |
|---|---|
| Mean length | 9.486179059 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 47.3% | |
| Uppercase_Letter | 24 | 43.6% | |
| Space_Separator | 1 | 1.8% | |
| Dash_Punctuation | 1 | 1.8% | |
| Open_Punctuation | 1 | 1.8% | |
| Decimal_Number | 1 | 1.8% | |
| Close_Punctuation | 1 | 1.8% |
| Value | Count | Frequency (%) | |
| Latin | 50 | 90.9% | |
| Common | 5 | 9.1% |
| Value | Count | Frequency (%) | |
| ASCII | 55 | 100.0% |
is_super_over
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 1 | 81 |
| Value | Count | Frequency (%) | |
| 0 | 164669 | > 99.9% | |
| 1 | 81 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03718361153262519 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 159739 |
| Zeros (%) | 97.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2540868115 |
|---|---|
| Coefficient of variation (CV) | 6.833301044 |
| Kurtosis | 190.261922 |
| Mean | 0.03718361153 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.65335186 |
| Sum | 6126 |
| Variance | 0.06456010777 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 159739 | 97.0% | |
| 1 | 4546 | 2.8% | |
| 2 | 219 | 0.1% | |
| 5 | 200 | 0.1% | |
| 3 | 42 | < 0.1% | |
| 4 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 159739 | 97.0% | |
| 1 | 4546 | 2.8% | |
| 2 | 219 | 0.1% | |
| 3 | 42 | < 0.1% | |
| 4 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 200 | 0.1% | |
| 4 | 4 | < 0.1% | |
| 3 | 42 | < 0.1% | |
| 2 | 219 | 0.1% | |
| 1 | 4546 | 2.8% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.004898330804248862 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 164302 |
| Zeros (%) | 99.7% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1150063737 |
|---|---|
| Coefficient of variation (CV) | 23.47868658 |
| Kurtosis | 991.9717646 |
| Mean | 0.004898330804 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 30.0515634 |
| Sum | 807 |
| Variance | 0.013226466 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 164302 | 99.7% | |
| 1 | 309 | 0.2% | |
| 4 | 109 | 0.1% | |
| 2 | 28 | < 0.1% | |
| 3 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 164302 | 99.7% | |
| 1 | 309 | 0.2% | |
| 2 | 28 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 109 | 0.1% |
| Value | Count | Frequency (%) | |
| 4 | 109 | 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 28 | < 0.1% | |
| 1 | 309 | 0.2% | |
| 0 | 164302 | 99.7% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.021547799696509863 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 161989 |
| Zeros (%) | 98.3% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1964100243 |
|---|---|
| Coefficient of variation (CV) | 9.115084931 |
| Kurtosis | 237.683774 |
| Mean | 0.0215477997 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.63127607 |
| Sum | 3550 |
| Variance | 0.03857689765 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 161989 | 98.3% | |
| 1 | 2408 | 1.5% | |
| 4 | 204 | 0.1% | |
| 2 | 129 | 0.1% | |
| 3 | 16 | < 0.1% | |
| 5 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 161989 | 98.3% | |
| 1 | 2408 | 1.5% | |
| 2 | 129 | 0.1% | |
| 3 | 16 | < 0.1% | |
| 4 | 204 | 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 4 | < 0.1% | |
| 4 | 204 | 0.1% | |
| 3 | 16 | < 0.1% | |
| 2 | 129 | 0.1% | |
| 1 | 2408 | 1.5% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.004200303490136571 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 164093 |
| Zeros (%) | 99.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.07111078137 |
|---|---|
| Coefficient of variation (CV) | 16.92991507 |
| Kurtosis | 1086.84229 |
| Mean | 0.00420030349 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.97400437 |
| Sum | 692 |
| Variance | 0.005056743227 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 164093 | 99.6% | |
| 1 | 641 | 0.4% | |
| 2 | 9 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 164093 | 99.6% | |
| 1 | 641 | 0.4% | |
| 2 | 9 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 6 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 1 | 641 | 0.4% | |
| 0 | 164093 | 99.6% |
penalty_runs
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 5 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 164748 | > 99.9% | |
| 5 | 2 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.237238239757208 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 65904 |
| Zeros (%) | 40.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.60351116 |
|---|---|
| Coefficient of variation (CV) | 1.296040737 |
| Kurtosis | 1.65714855 |
| Mean | 1.23723824 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.588431135 |
| Sum | 203835 |
| Variance | 2.57124804 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 65904 | 40.0% | |
| 1 | 61580 | 37.4% | |
| 4 | 18707 | 11.4% | |
| 2 | 10560 | 6.4% | |
| 6 | 7392 | 4.5% | |
| 3 | 543 | 0.3% | |
| 5 | 61 | < 0.1% | |
| 7 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 65904 | 40.0% | |
| 1 | 61580 | 37.4% | |
| 2 | 10560 | 6.4% | |
| 3 | 543 | 0.3% | |
| 4 | 18707 | 11.4% |
| Value | Count | Frequency (%) | |
| 7 | 3 | < 0.1% | |
| 6 | 7392 | 4.5% | |
| 5 | 61 | < 0.1% | |
| 4 | 18707 | 11.4% | |
| 3 | 543 | 0.3% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0678907435508346 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 155872 |
| Zeros (%) | 94.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3451441709 |
|---|---|
| Coefficient of variation (CV) | 5.083817805 |
| Kurtosis | 90.58208075 |
| Mean | 0.06789074355 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.205429887 |
| Sum | 11185 |
| Variance | 0.1191244987 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 155872 | 94.6% | |
| 1 | 7904 | 4.8% | |
| 2 | 384 | 0.2% | |
| 4 | 317 | 0.2% | |
| 5 | 211 | 0.1% | |
| 3 | 61 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 155872 | 94.6% | |
| 1 | 7904 | 4.8% | |
| 2 | 384 | 0.2% | |
| 3 | 61 | < 0.1% | |
| 4 | 317 | 0.2% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 5 | 211 | 0.1% | |
| 4 | 317 | 0.2% | |
| 3 | 61 | < 0.1% | |
| 2 | 384 | 0.2% |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3051289833080424 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 58061 |
| Zeros (%) | 35.2% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.596254558 |
|---|---|
| Coefficient of variation (CV) | 1.223062684 |
| Kurtosis | 1.626415024 |
| Mean | 1.305128983 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.558685952 |
| Sum | 215020 |
| Variance | 2.548028613 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 67672 | 41.1% | |
| 0 | 58061 | 35.2% | |
| 4 | 18914 | 11.5% | |
| 2 | 11696 | 7.1% | |
| 6 | 7360 | 4.5% | |
| 3 | 643 | 0.4% | |
| 5 | 333 | 0.2% | |
| 7 | 38 | < 0.1% | |
| 8 | 25 | < 0.1% | |
| 10 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 58061 | 35.2% | |
| 1 | 67672 | 41.1% | |
| 2 | 11696 | 7.1% | |
| 3 | 643 | 0.4% | |
| 4 | 18914 | 11.5% |
| Value | Count | Frequency (%) | |
| 10 | 8 | < 0.1% | |
| 8 | 25 | < 0.1% | |
| 7 | 38 | < 0.1% | |
| 6 | 7360 | 4.5% | |
| 5 | 333 | 0.2% |
| Distinct count | 464 |
|---|---|
| Unique (%) | 5.7% |
| Missing | 156593 |
| Missing (%) | 95.0% |
| Memory size | 1.3 MiB |
| SK Raina | 146 |
|---|---|
| RV Uthappa | 144 |
| RG Sharma | 141 |
| G Gambhir | 136 |
| V Kohli | 129 |
| Other values (459) |
| Value | Count | Frequency (%) | |
| SK Raina | 146 | 0.1% | |
| RV Uthappa | 144 | 0.1% | |
| RG Sharma | 141 | 0.1% | |
| G Gambhir | 136 | 0.1% | |
| V Kohli | 129 | 0.1% | |
| KD Karthik | 127 | 0.1% | |
| S Dhawan | 123 | 0.1% | |
| PA Patel | 112 | 0.1% | |
| Yuvraj Singh | 107 | 0.1% | |
| YK Pathan | 107 | 0.1% | |
| Other values (454) | 6885 | 4.2% | |
| (Missing) | 156593 | 95.0% |
Length
| Max length | 20 |
|---|---|
| Mean length | 3.316698027 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 48.1% | |
| Uppercase_Letter | 26 | 48.1% | |
| Space_Separator | 1 | 1.9% | |
| Dash_Punctuation | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 96.3% | |
| Common | 2 | 3.7% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 156593 |
| Missing (%) | 95.0% |
| Memory size | 1.3 MiB |
| caught | |
|---|---|
| bowled | |
| run out | 813 |
| lbw | 494 |
| stumped | 262 |
| Other values (4) | 232 |
| Value | Count | Frequency (%) | |
| caught | 4861 | 3.0% | |
| bowled | 1495 | 0.9% | |
| run out | 813 | 0.5% | |
| lbw | 494 | 0.3% | |
| stumped | 262 | 0.2% | |
| caught and bowled | 211 | 0.1% | |
| retired hurt | 11 | < 0.1% | |
| hit wicket | 9 | < 0.1% | |
| obstructing the field | 1 | < 0.1% | |
| (Missing) | 156593 | 95.0% |
Length
| Max length | 21 |
|---|---|
| Mean length | 3.160861912 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 20 | 95.2% | |
| Space_Separator | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
| Distinct count | 476 |
|---|---|
| Unique (%) | 8.0% |
| Missing | 158832 |
| Missing (%) | 96.4% |
| Memory size | 1.3 MiB |
| KD Karthik | 145 |
|---|---|
| MS Dhoni | 142 |
| RV Uthappa | 120 |
| AB de Villiers | 108 |
| SK Raina | 107 |
| Other values (471) |
| Value | Count | Frequency (%) | |
| KD Karthik | 145 | 0.1% | |
| MS Dhoni | 142 | 0.1% | |
| RV Uthappa | 120 | 0.1% | |
| AB de Villiers | 108 | 0.1% | |
| SK Raina | 107 | 0.1% | |
| PA Patel | 88 | 0.1% | |
| RG Sharma | 87 | 0.1% | |
| V Kohli | 84 | 0.1% | |
| NV Ojha | 82 | < 0.1% | |
| WP Saha | 78 | < 0.1% | |
| Other values (466) | 4877 | 3.0% | |
| (Missing) | 158832 | 96.4% |
Length
| Max length | 21 |
|---|---|
| Mean length | 3.233414264 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 47.3% | |
| Uppercase_Letter | 25 | 45.5% | |
| Space_Separator | 1 | 1.8% | |
| Open_Punctuation | 1 | 1.8% | |
| Close_Punctuation | 1 | 1.8% | |
| Dash_Punctuation | 1 | 1.8% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 92.7% | |
| Common | 4 | 7.3% |
| Value | Count | Frequency (%) | |
| ASCII | 55 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| match_id | inning | batting_team | bowling_team | over | ball | batsman | non_striker | bowler | is_super_over | wide_runs | bye_runs | legbye_runs | noball_runs | penalty_runs | batsman_runs | extra_runs | total_runs | player_dismissed | dismissal_kind | fielder | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 1 | DA Warner | S Dhawan | TS Mills | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 1 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 2 | DA Warner | S Dhawan | TS Mills | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 2 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 3 | DA Warner | S Dhawan | TS Mills | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |
| 3 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 4 | DA Warner | S Dhawan | TS Mills | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 4 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 5 | DA Warner | S Dhawan | TS Mills | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | NaN | NaN | NaN |
| 5 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 6 | S Dhawan | DA Warner | TS Mills | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 6 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 1 | 7 | S Dhawan | DA Warner | TS Mills | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | NaN | NaN | NaN |
| 7 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 2 | 1 | S Dhawan | DA Warner | A Choudhary | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | NaN | NaN | NaN |
| 8 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 2 | 2 | DA Warner | S Dhawan | A Choudhary | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |
| 9 | 1 | 1 | Sunrisers Hyderabad | Royal Challengers Bangalore | 2 | 3 | DA Warner | S Dhawan | A Choudhary | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | NaN | NaN | NaN |
Last rows
| match_id | inning | batting_team | bowling_team | over | ball | batsman | non_striker | bowler | is_super_over | wide_runs | bye_runs | legbye_runs | noball_runs | penalty_runs | batsman_runs | extra_runs | total_runs | player_dismissed | dismissal_kind | fielder | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164740 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 17 | 6 | SR Watson | AT Rayudu | Rashid Khan | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |
| 164741 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 1 | AT Rayudu | SR Watson | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | NaN | NaN | NaN |
| 164742 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 2 | SR Watson | AT Rayudu | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | NaN | NaN | NaN |
| 164743 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 3 | AT Rayudu | SR Watson | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | NaN | NaN | NaN |
| 164744 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 4 | SR Watson | AT Rayudu | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |
| 164745 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 5 | SR Watson | AT Rayudu | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |
| 164746 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 18 | 6 | SR Watson | AT Rayudu | S Kaul | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 164747 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 19 | 1 | AT Rayudu | SR Watson | CR Brathwaite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 164748 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 19 | 2 | AT Rayudu | SR Watson | CR Brathwaite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN | NaN |
| 164749 | 7953 | 2 | Chennai Super Kings | Sunrisers Hyderabad | 19 | 3 | AT Rayudu | SR Watson | CR Brathwaite | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | NaN | NaN | NaN |